/*
 Navicat Premium Data Transfer

 Source Server         : yancy
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : 127.0.0.1:3306
 Source Schema         : books

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 14/07/2021 23:34:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` VALUES (1, 'testTask', 'renren', '0 0/30 * * * ?', 0, '参数测试', '2021-06-26 14:44:49');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4  COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job_log` VALUES (1, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-26 15:00:00');
INSERT INTO `schedule_job_log` VALUES (2, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-26 15:30:00');
INSERT INTO `schedule_job_log` VALUES (3, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-26 16:00:00');
INSERT INTO `schedule_job_log` VALUES (4, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-26 16:30:00');
INSERT INTO `schedule_job_log` VALUES (5, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-26 17:00:00');
INSERT INTO `schedule_job_log` VALUES (6, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 09:30:00');
INSERT INTO `schedule_job_log` VALUES (7, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 10:00:00');
INSERT INTO `schedule_job_log` VALUES (8, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 10:30:00');
INSERT INTO `schedule_job_log` VALUES (9, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 11:00:00');
INSERT INTO `schedule_job_log` VALUES (10, 1, 'testTask', 'renren', 0, NULL, 2, '2021-06-27 11:30:00');
INSERT INTO `schedule_job_log` VALUES (11, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 12:00:00');
INSERT INTO `schedule_job_log` VALUES (12, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 12:30:00');
INSERT INTO `schedule_job_log` VALUES (13, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 13:00:00');
INSERT INTO `schedule_job_log` VALUES (14, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 13:30:00');
INSERT INTO `schedule_job_log` VALUES (15, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 14:00:00');
INSERT INTO `schedule_job_log` VALUES (16, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 14:30:00');
INSERT INTO `schedule_job_log` VALUES (17, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 15:00:00');
INSERT INTO `schedule_job_log` VALUES (18, 1, 'testTask', 'renren', 0, NULL, 2, '2021-06-27 15:30:00');
INSERT INTO `schedule_job_log` VALUES (19, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 16:00:00');
INSERT INTO `schedule_job_log` VALUES (20, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 16:30:00');
INSERT INTO `schedule_job_log` VALUES (21, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 17:00:00');
INSERT INTO `schedule_job_log` VALUES (22, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 17:30:00');
INSERT INTO `schedule_job_log` VALUES (23, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 18:00:00');
INSERT INTO `schedule_job_log` VALUES (24, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 18:30:00');
INSERT INTO `schedule_job_log` VALUES (25, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 19:00:00');
INSERT INTO `schedule_job_log` VALUES (26, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 19:30:00');
INSERT INTO `schedule_job_log` VALUES (27, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 20:00:00');
INSERT INTO `schedule_job_log` VALUES (28, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 20:30:00');
INSERT INTO `schedule_job_log` VALUES (29, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 21:00:00');
INSERT INTO `schedule_job_log` VALUES (30, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 21:30:00');
INSERT INTO `schedule_job_log` VALUES (31, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 22:00:00');
INSERT INTO `schedule_job_log` VALUES (32, 1, 'testTask', 'renren', 0, NULL, 0, '2021-06-27 22:30:00');
INSERT INTO `schedule_job_log` VALUES (33, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 23:00:00');
INSERT INTO `schedule_job_log` VALUES (34, 1, 'testTask', 'renren', 0, NULL, 1, '2021-06-27 23:30:00');
INSERT INTO `schedule_job_log` VALUES (35, 1, 'testTask', 'renren', 0, NULL, 15, '2021-06-28 00:00:00');
INSERT INTO `schedule_job_log` VALUES (36, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 12:30:00');
INSERT INTO `schedule_job_log` VALUES (37, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-03 13:00:00');
INSERT INTO `schedule_job_log` VALUES (38, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 13:30:00');
INSERT INTO `schedule_job_log` VALUES (39, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 14:00:00');
INSERT INTO `schedule_job_log` VALUES (40, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 14:30:00');
INSERT INTO `schedule_job_log` VALUES (41, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 15:00:00');
INSERT INTO `schedule_job_log` VALUES (42, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-03 15:30:00');
INSERT INTO `schedule_job_log` VALUES (43, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 16:30:00');
INSERT INTO `schedule_job_log` VALUES (44, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-03 17:00:00');
INSERT INTO `schedule_job_log` VALUES (45, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 17:30:00');
INSERT INTO `schedule_job_log` VALUES (46, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 18:00:00');
INSERT INTO `schedule_job_log` VALUES (47, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-03 18:30:00');
INSERT INTO `schedule_job_log` VALUES (48, 1, 'testTask', 'renren', 0, NULL, 3, '2021-07-03 19:00:00');
INSERT INTO `schedule_job_log` VALUES (49, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-03 19:30:00');
INSERT INTO `schedule_job_log` VALUES (50, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 20:00:00');
INSERT INTO `schedule_job_log` VALUES (51, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-03 20:30:00');
INSERT INTO `schedule_job_log` VALUES (52, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-03 21:00:00');
INSERT INTO `schedule_job_log` VALUES (53, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 12:00:00');
INSERT INTO `schedule_job_log` VALUES (54, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 12:30:00');
INSERT INTO `schedule_job_log` VALUES (55, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 13:00:00');
INSERT INTO `schedule_job_log` VALUES (56, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 13:30:00');
INSERT INTO `schedule_job_log` VALUES (57, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 14:00:00');
INSERT INTO `schedule_job_log` VALUES (58, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-04 14:30:00');
INSERT INTO `schedule_job_log` VALUES (59, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-04 15:00:00');
INSERT INTO `schedule_job_log` VALUES (60, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 15:30:00');
INSERT INTO `schedule_job_log` VALUES (61, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 16:00:00');
INSERT INTO `schedule_job_log` VALUES (62, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 16:30:00');
INSERT INTO `schedule_job_log` VALUES (63, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-04 17:00:00');
INSERT INTO `schedule_job_log` VALUES (64, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 17:30:00');
INSERT INTO `schedule_job_log` VALUES (65, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-04 18:00:00');
INSERT INTO `schedule_job_log` VALUES (66, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-04 18:30:00');
INSERT INTO `schedule_job_log` VALUES (67, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 19:00:00');
INSERT INTO `schedule_job_log` VALUES (68, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 19:30:00');
INSERT INTO `schedule_job_log` VALUES (69, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 20:00:00');
INSERT INTO `schedule_job_log` VALUES (70, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 20:30:00');
INSERT INTO `schedule_job_log` VALUES (71, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 21:00:00');
INSERT INTO `schedule_job_log` VALUES (72, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 21:30:00');
INSERT INTO `schedule_job_log` VALUES (73, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 22:00:00');
INSERT INTO `schedule_job_log` VALUES (74, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-04 22:30:00');
INSERT INTO `schedule_job_log` VALUES (75, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-04 23:00:00');
INSERT INTO `schedule_job_log` VALUES (76, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-10 16:00:00');
INSERT INTO `schedule_job_log` VALUES (77, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-10 16:30:00');
INSERT INTO `schedule_job_log` VALUES (78, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-10 17:00:00');
INSERT INTO `schedule_job_log` VALUES (79, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 17:30:00');
INSERT INTO `schedule_job_log` VALUES (80, 1, 'testTask', 'renren', 0, NULL, 53, '2021-07-10 18:00:05');
INSERT INTO `schedule_job_log` VALUES (81, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 18:30:00');
INSERT INTO `schedule_job_log` VALUES (82, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-10 19:00:00');
INSERT INTO `schedule_job_log` VALUES (83, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 19:30:00');
INSERT INTO `schedule_job_log` VALUES (84, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 20:00:00');
INSERT INTO `schedule_job_log` VALUES (85, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-10 20:30:00');
INSERT INTO `schedule_job_log` VALUES (86, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 21:00:00');
INSERT INTO `schedule_job_log` VALUES (87, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 21:30:00');
INSERT INTO `schedule_job_log` VALUES (88, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 22:00:00');
INSERT INTO `schedule_job_log` VALUES (89, 1, 'testTask', 'renren', 0, NULL, 2, '2021-07-10 22:30:00');
INSERT INTO `schedule_job_log` VALUES (90, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 23:00:01');
INSERT INTO `schedule_job_log` VALUES (91, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-10 23:30:00');
INSERT INTO `schedule_job_log` VALUES (92, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 11:00:00');
INSERT INTO `schedule_job_log` VALUES (93, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 11:30:00');
INSERT INTO `schedule_job_log` VALUES (94, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 12:00:00');
INSERT INTO `schedule_job_log` VALUES (95, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 12:30:00');
INSERT INTO `schedule_job_log` VALUES (96, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 13:00:00');
INSERT INTO `schedule_job_log` VALUES (97, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 13:30:00');
INSERT INTO `schedule_job_log` VALUES (98, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 14:00:00');
INSERT INTO `schedule_job_log` VALUES (99, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 14:30:00');
INSERT INTO `schedule_job_log` VALUES (100, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 15:00:00');
INSERT INTO `schedule_job_log` VALUES (101, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 15:30:00');
INSERT INTO `schedule_job_log` VALUES (102, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 16:00:00');
INSERT INTO `schedule_job_log` VALUES (103, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 16:30:00');
INSERT INTO `schedule_job_log` VALUES (104, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 17:00:00');
INSERT INTO `schedule_job_log` VALUES (105, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 17:30:00');
INSERT INTO `schedule_job_log` VALUES (106, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 18:00:00');
INSERT INTO `schedule_job_log` VALUES (107, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 18:30:00');
INSERT INTO `schedule_job_log` VALUES (108, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 19:00:00');
INSERT INTO `schedule_job_log` VALUES (109, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 19:30:00');
INSERT INTO `schedule_job_log` VALUES (110, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 20:00:00');
INSERT INTO `schedule_job_log` VALUES (111, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 20:30:00');
INSERT INTO `schedule_job_log` VALUES (112, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 21:00:00');
INSERT INTO `schedule_job_log` VALUES (113, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 21:30:00');
INSERT INTO `schedule_job_log` VALUES (114, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 22:00:00');
INSERT INTO `schedule_job_log` VALUES (115, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 22:30:00');
INSERT INTO `schedule_job_log` VALUES (116, 1, 'testTask', 'renren', 0, NULL, 0, '2021-07-11 23:00:00');
INSERT INTO `schedule_job_log` VALUES (117, 1, 'testTask', 'renren', 0, NULL, 1, '2021-07-11 23:30:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_author
-- ----------------------------
DROP TABLE IF EXISTS `sys_author`;
CREATE TABLE `sys_author` (
  `author_id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `status` tinyint DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`author_id`) USING BTREE,
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4  COMMENT='系统用户';

-- ----------------------------
-- Records of sys_author
-- ----------------------------
BEGIN;
INSERT INTO `sys_author` VALUES (1, '隆美尔', 'root@renren.io', 1, 1, '2016-11-11 11:11:11');
INSERT INTO `sys_author` VALUES (2, '曼施坦因', '1249123382@qq.com', 1, 1, '2021-06-26 14:51:45');
INSERT INTO `sys_author` VALUES (3, '古德里安', 'gdas@qq.com', 1, 1, '2021-06-27 09:04:08');
COMMIT;

-- ----------------------------
-- Table structure for sys_book
-- ----------------------------
DROP TABLE IF EXISTS `sys_book`;
CREATE TABLE `sys_book` (
  `book_id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `version` varchar(255) DEFAULT NULL COMMENT '版本',
  `vendor` varchar(255) DEFAULT NULL COMMENT '出版社',
  `public_date` date DEFAULT NULL,
  `summary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '摘要',
  `total` int DEFAULT '0' COMMENT '当前图书的总数量',
  `available` int DEFAULT '0' COMMENT '当前图书的剩余可借阅数量',
  `status` tinyint DEFAULT '1',
  `create_user_id` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_book
-- ----------------------------
BEGIN;
INSERT INTO `sys_book` VALUES (1, '我的奋斗2', '4.0', '德国人民出版社2', '2021-06-12', '这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2', 20, 0, 1, 1, '2021-06-27 11:29:50');
INSERT INTO `sys_book` VALUES (2, '1234', '1234', '1234', '2021-06-25', '1234', 3, 0, 1, 1, '2021-06-27 14:51:40');
INSERT INTO `sys_book` VALUES (3, '1', '1', '1', '2021-06-29', '1', 1, 1, 0, 1, '2021-06-27 14:53:36');
INSERT INTO `sys_book` VALUES (4, '你是我的眼', '1.0.1', '中国人民出版社', '2021-07-31', '真是一本好书啊', 100, 80, 1, 1, '2021-07-03 12:50:46');
COMMIT;

-- ----------------------------
-- Table structure for sys_book_author
-- ----------------------------
DROP TABLE IF EXISTS `sys_book_author`;
CREATE TABLE `sys_book_author` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `book_id` bigint NOT NULL,
  `author_id` bigint NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '是否有效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_book_author
-- ----------------------------
BEGIN;
INSERT INTO `sys_book_author` VALUES (39, 1, 1, 1);
INSERT INTO `sys_book_author` VALUES (40, 1, 2, 1);
INSERT INTO `sys_book_author` VALUES (41, 3, 1, 1);
INSERT INTO `sys_book_author` VALUES (44, 4, 1, 1);
INSERT INTO `sys_book_author` VALUES (45, 4, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_borrow_book
-- ----------------------------
DROP TABLE IF EXISTS `sys_borrow_book`;
CREATE TABLE `sys_borrow_book` (
  `borrow_id` bigint NOT NULL AUTO_INCREMENT,
  `book_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `total` int DEFAULT '1' COMMENT '总共借阅的数量',
  `need_back` int DEFAULT NULL COMMENT '还需要还的数量。刚开始与total数量一样，need_back值为0表示书已全部还完',
  `status` tinyint DEFAULT '1',
  `create_user_id` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `limit_time` datetime DEFAULT NULL COMMENT '限定还书时间',
  PRIMARY KEY (`borrow_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_borrow_book
-- ----------------------------
BEGIN;
INSERT INTO `sys_borrow_book` VALUES (7, 2, 1, 1, 1, 1, 1, '2021-07-04 15:58:21', '2021-07-30 00:00:00');
INSERT INTO `sys_borrow_book` VALUES (8, 2, 1, 1, 0, 1, 1, '2021-07-04 16:08:47', '2021-07-31 00:00:00');
INSERT INTO `sys_borrow_book` VALUES (9, 2, 1, 2, 2, 1, 1, '2021-07-04 16:09:03', '2021-07-22 00:00:00');
INSERT INTO `sys_borrow_book` VALUES (10, 4, 1, 20, 16, 1, 1, '2021-07-10 15:37:31', '2021-07-16 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_borrow_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_borrow_log`;
CREATE TABLE `sys_borrow_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL,
  `book_id` bigint DEFAULT NULL,
  `type` int DEFAULT NULL COMMENT '1:借书 2：还书',
  `total` int DEFAULT NULL COMMENT '书籍数量',
  `status` tinyint DEFAULT NULL,
  `create_user_id` bigint DEFAULT NULL COMMENT '操作人',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_borrow_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_borrow_log` VALUES (1, 1, 4, 2, 1, 1, 1, '2021-07-11 18:16:14');
COMMIT;

-- ----------------------------
-- Table structure for sys_captcha
-- ----------------------------
DROP TABLE IF EXISTS `sys_captcha`;
CREATE TABLE `sys_captcha` (
  `uuid` char(36) NOT NULL COMMENT 'uuid',
  `code` varchar(6) NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4  COMMENT='系统验证码';

-- ----------------------------
-- Records of sys_captcha
-- ----------------------------
BEGIN;
INSERT INTO `sys_captcha` VALUES ('71e57d4b-910c-4b45-8cac-6967855cf0e0', 'g8abn', '2021-07-04 11:58:10');
INSERT INTO `sys_captcha` VALUES ('99fe2e5c-4fc3-4aad-8ef4-d1dbd5e596a0', '348fp', '2021-06-27 14:52:09');
INSERT INTO `sys_captcha` VALUES ('b5db948f-93ef-4465-814d-a785700a9b7f', 'nnfbp', '2021-06-27 09:08:31');
INSERT INTO `sys_captcha` VALUES ('bf98d9d3-5f7e-4157-8464-0243db3c6884', 'g2mmg', '2021-06-26 14:56:00');
INSERT INTO `sys_captcha` VALUES ('e837ecd7-99e0-4348-8820-f38f38f24355', 'empce', '2021-07-03 12:51:47');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `param_key` varchar(50) DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `param_key` (`param_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4  COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', 0, '云存储配置信息');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `file_id` bigint NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` tinyint DEFAULT '1',
  `create_user_id` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4  COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1, 'admin', '保存用户', 'SysUserController.save()', '[{\"userId\":2,\"username\":\"yancy\",\"password\":\"ce218fc25a13eb29b24b37a99fe098d9b23a55d71445adbc591947a73be9c2c8\",\"salt\":\"3tE26TobdgrwuRGzSjuk\",\"email\":\"1249123382@qq.com\",\"mobile\":\"15036616562\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Jun 26, 2021, 2:51:44 PM\"}]', 89, '0:0:0:0:0:0:0:1', '2021-06-26 14:51:45');
INSERT INTO `sys_log` VALUES (2, 'admin', '修改用户', 'SysUserController.update()', '[{\"userId\":1,\"username\":\"admin\",\"password\":\"12e416902db93462bf888e3dc0792be42ecd8a54a6c8ca63ba68cdd35947da15\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13612345678\",\"status\":1,\"roleIdList\":[],\"createUserId\":1}]', 22, '0:0:0:0:0:0:0:1', '2021-06-26 14:54:47');
INSERT INTO `sys_log` VALUES (3, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":31,\"parentId\":1,\"name\":\"作者管理\",\"url\":\"sys/author\",\"perms\":\"\",\"type\":1,\"icon\":\"geren\",\"orderNum\":0}]', 14, '0:0:0:0:0:0:0:1', '2021-06-26 15:03:52');
INSERT INTO `sys_log` VALUES (4, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":1,\"roleName\":\"角色1\",\"remark\":\"角色1\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,-666666],\"createTime\":\"Jun 26, 2021, 4:03:46 PM\"}]', 92, '0:0:0:0:0:0:0:1', '2021-06-26 16:03:46');
INSERT INTO `sys_log` VALUES (5, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":2,\"roleName\":\"角色2\",\"remark\":\"角色2\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,-666666],\"createTime\":\"Jun 26, 2021, 4:03:56 PM\"}]', 44, '0:0:0:0:0:0:0:1', '2021-06-26 16:03:56');
INSERT INTO `sys_log` VALUES (6, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":3,\"roleName\":\"角色3\",\"remark\":\"角色3\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,-666666],\"createTime\":\"Jun 26, 2021, 4:04:06 PM\"}]', 39, '0:0:0:0:0:0:0:1', '2021-06-26 16:04:07');
INSERT INTO `sys_log` VALUES (7, 'admin', '保存用户', 'SysUserController.save()', '[{\"userId\":3,\"username\":\"test\",\"password\":\"5b18dd289c913342d5befa549dd4ee5ecf5a67f2924ff93551a45606f9055c7d\",\"salt\":\"OSxJf8kqFfNzQSB05M9W\",\"email\":\"1234@1234.com\",\"mobile\":\"15036616562\",\"status\":1,\"roleIdList\":[3,2,1],\"createUserId\":1,\"createTime\":\"Jun 26, 2021, 4:04:54 PM\"}]', 41, '0:0:0:0:0:0:0:1', '2021-06-26 16:04:55');
INSERT INTO `sys_log` VALUES (8, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":1,\"username\":\"隆美尔2\",\"email\":\"root@renren.io\",\"status\":1,\"createUserId\":1}]', 17, '0:0:0:0:0:0:0:1', '2021-06-26 17:51:03');
INSERT INTO `sys_log` VALUES (9, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":1,\"username\":\"隆美尔3\",\"email\":\"root@renren.io3\",\"status\":0,\"createUserId\":1}]', 35, '0:0:0:0:0:0:0:1', '2021-06-26 17:51:15');
INSERT INTO `sys_log` VALUES (10, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":1,\"username\":\"隆美尔\",\"email\":\"root@renren.io\",\"status\":1,\"createUserId\":1}]', 15, '0:0:0:0:0:0:0:1', '2021-06-26 17:51:25');
INSERT INTO `sys_log` VALUES (11, 'admin', '保存用户', 'SysAuthorController.save()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 9:04:07 AM\"}]', 557, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:08');
INSERT INTO `sys_log` VALUES (12, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":0,\"createUserId\":1}]', 19, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:18');
INSERT INTO `sys_log` VALUES (13, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 13, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:28');
INSERT INTO `sys_log` VALUES (14, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 5, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:28');
INSERT INTO `sys_log` VALUES (15, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 2, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:28');
INSERT INTO `sys_log` VALUES (16, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 7, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:28');
INSERT INTO `sys_log` VALUES (17, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 7, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:28');
INSERT INTO `sys_log` VALUES (18, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 4, '0:0:0:0:0:0:0:1', '2021-06-27 09:04:29');
INSERT INTO `sys_log` VALUES (19, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 4, '0:0:0:0:0:0:0:1', '2021-06-27 09:14:49');
INSERT INTO `sys_log` VALUES (20, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 6, '0:0:0:0:0:0:0:1', '2021-06-27 09:14:54');
INSERT INTO `sys_log` VALUES (21, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 5, '0:0:0:0:0:0:0:1', '2021-06-27 09:14:58');
INSERT INTO `sys_log` VALUES (22, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 5, '0:0:0:0:0:0:0:1', '2021-06-27 09:14:59');
INSERT INTO `sys_log` VALUES (23, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 8, '0:0:0:0:0:0:0:1', '2021-06-27 09:15:11');
INSERT INTO `sys_log` VALUES (24, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 5, '0:0:0:0:0:0:0:1', '2021-06-27 09:15:12');
INSERT INTO `sys_log` VALUES (25, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 9, '0:0:0:0:0:0:0:1', '2021-06-27 09:15:16');
INSERT INTO `sys_log` VALUES (26, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 7, '0:0:0:0:0:0:0:1', '2021-06-27 09:15:17');
INSERT INTO `sys_log` VALUES (27, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 6, '0:0:0:0:0:0:0:1', '2021-06-27 09:17:06');
INSERT INTO `sys_log` VALUES (28, 'admin', '修改用户', 'SysAuthorController.update()', '[{\"authorId\":3,\"username\":\"古德里安\",\"email\":\"gdas@qq.com\",\"status\":1,\"createUserId\":1}]', 3, '0:0:0:0:0:0:0:1', '2021-06-27 09:24:21');
INSERT INTO `sys_log` VALUES (29, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":32,\"parentId\":1,\"name\":\"图书管理\",\"url\":\"sys/book\",\"perms\":\"\",\"type\":1,\"icon\":\"log\",\"orderNum\":0}]', 16, '0:0:0:0:0:0:0:1', '2021-06-27 11:31:10');
INSERT INTO `sys_log` VALUES (30, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":33,\"parentId\":1,\"name\":\"图书管理\",\"url\":\"sys/book\",\"perms\":\"\",\"type\":1,\"icon\":\"log\",\"orderNum\":0}]', 11, '0:0:0:0:0:0:0:1', '2021-06-27 11:31:12');
INSERT INTO `sys_log` VALUES (31, 'admin', '删除菜单', 'SysMenuController.delete()', '[33]', 42, '0:0:0:0:0:0:0:1', '2021-06-27 11:31:23');
INSERT INTO `sys_log` VALUES (32, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2,3]}]', 364, '0:0:0:0:0:0:0:1', '2021-06-27 14:14:50');
INSERT INTO `sys_log` VALUES (33, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[3,4,5,1,2]}]', 26, '0:0:0:0:0:0:0:1', '2021-06-27 14:15:02');
INSERT INTO `sys_log` VALUES (34, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[6,7,8,9,10,1,2]}]', 25, '0:0:0:0:0:0:0:1', '2021-06-27 14:16:07');
INSERT INTO `sys_log` VALUES (35, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[11,12,13,14,15,16,17]}]', 27, '0:0:0:0:0:0:0:1', '2021-06-27 14:16:27');
INSERT INTO `sys_log` VALUES (36, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2,3]}]', 58, '0:0:0:0:0:0:0:1', '2021-06-27 14:23:20');
INSERT INTO `sys_log` VALUES (37, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[2]}]', 21, '0:0:0:0:0:0:0:1', '2021-06-27 14:23:30');
INSERT INTO `sys_log` VALUES (38, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":96,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[2]}]', 30, '0:0:0:0:0:0:0:1', '2021-06-27 14:23:38');
INSERT INTO `sys_log` VALUES (39, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 27, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":96,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[2]}]', 24, '0:0:0:0:0:0:0:1', '2021-06-27 14:26:34');
INSERT INTO `sys_log` VALUES (40, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗\",\"version\":\"2.0\",\"vendor\":\"德国人民出版社\",\"publicDate\":\"Jun 2, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗\",\"total\":96,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[2]}]', 20, '0:0:0:0:0:0:0:1', '2021-06-27 14:28:10');
INSERT INTO `sys_log` VALUES (41, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗2\",\"version\":\"4.0\",\"vendor\":\"德国人民出版社2\",\"publicDate\":\"Jun 12, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2\",\"total\":92,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[]}]', 22, '0:0:0:0:0:0:0:1', '2021-06-27 14:28:33');
INSERT INTO `sys_log` VALUES (42, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗2\",\"version\":\"4.0\",\"vendor\":\"德国人民出版社2\",\"publicDate\":\"Jun 12, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2\",\"total\":92,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2]}]', 48, '0:0:0:0:0:0:0:1', '2021-06-27 14:28:44');
INSERT INTO `sys_log` VALUES (43, 'admin', '保存图书', 'SysBookController.save()', '[{\"bookId\":2,\"name\":\"1234\",\"version\":\"1234\",\"vendor\":\"1234\",\"publicDate\":\"Jun 25, 2021, 12:00:00 AM\",\"summary\":\"1234\",\"total\":3,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 2:51:39 PM\",\"authorIdList\":[]}]', 18, '0:0:0:0:0:0:0:1', '2021-06-27 14:51:40');
INSERT INTO `sys_log` VALUES (44, 'admin', '保存图书', 'SysBookController.save()', '[{\"bookId\":3,\"name\":\"1\",\"version\":\"1\",\"vendor\":\"1\",\"publicDate\":\"Jun 29, 2021, 12:00:00 AM\",\"summary\":\"1\",\"total\":1,\"available\":0,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 2:53:35 PM\",\"authorIdList\":[1]}]', 14, '0:0:0:0:0:0:0:1', '2021-06-27 14:53:36');
INSERT INTO `sys_log` VALUES (45, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗2\",\"version\":\"4.0\",\"vendor\":\"德国人民出版社2\",\"publicDate\":\"Jun 12, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2\",\"total\":95,\"available\":95,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2]}]', 80, '0:0:0:0:0:0:0:1', '2021-06-27 15:02:54');
INSERT INTO `sys_log` VALUES (46, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗2\",\"version\":\"4.0\",\"vendor\":\"德国人民出版社2\",\"publicDate\":\"Jun 12, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2\",\"total\":80,\"available\":60,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2]}]', 23, '0:0:0:0:0:0:0:1', '2021-06-27 15:03:24');
INSERT INTO `sys_log` VALUES (47, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":1,\"name\":\"我的奋斗2\",\"version\":\"4.0\",\"vendor\":\"德国人民出版社2\",\"publicDate\":\"Jun 12, 2021, 12:00:00 AM\",\"summary\":\"这不仅是我一个一个人的奋斗，还是全世界无产阶级人民的奋斗2\",\"total\":20,\"available\":0,\"status\":1,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 11:29:50 AM\",\"authorIdList\":[1,2]}]', 44, '0:0:0:0:0:0:0:1', '2021-06-27 15:03:58');
INSERT INTO `sys_log` VALUES (48, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":3,\"name\":\"1\",\"version\":\"1\",\"vendor\":\"1\",\"publicDate\":\"Jun 29, 2021, 12:00:00 AM\",\"summary\":\"1\",\"total\":1,\"available\":1,\"status\":0,\"createUserId\":1,\"createTime\":\"Jun 27, 2021, 2:53:36 PM\",\"authorIdList\":[1]}]', 47, '0:0:0:0:0:0:0:1', '2021-06-27 15:04:13');
INSERT INTO `sys_log` VALUES (49, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":34,\"parentId\":0,\"name\":\"书籍管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"log\",\"orderNum\":0}]', 15, '0:0:0:0:0:0:0:1', '2021-07-03 12:49:18');
INSERT INTO `sys_log` VALUES (50, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":35,\"parentId\":34,\"name\":\"借书管理\",\"url\":\"sys/borrow\",\"perms\":\"\",\"type\":1,\"icon\":\"admin\",\"orderNum\":0}]', 119, '0:0:0:0:0:0:0:1', '2021-07-03 12:49:56');
INSERT INTO `sys_log` VALUES (51, 'admin', '保存图书', 'SysBookController.save()', '[{\"bookId\":4,\"name\":\"你是我的眼\",\"version\":\"1.0.1\",\"vendor\":\"中国人民出版社\",\"publicDate\":\"Jul 31, 2021, 12:00:00 AM\",\"summary\":\"真是一本好书啊\",\"total\":100,\"available\":100,\"status\":1,\"createUserId\":1,\"createTime\":\"Jul 3, 2021, 12:50:46 PM\",\"authorIdList\":[1,2]}]', 306, '0:0:0:0:0:0:0:1', '2021-07-03 12:50:46');
INSERT INTO `sys_log` VALUES (52, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":1,\"bookId\":1,\"userId\":1,\"total\":0,\"createUserId\":1}]', 42, '0:0:0:0:0:0:0:1', '2021-07-04 15:44:23');
INSERT INTO `sys_log` VALUES (53, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":2,\"bookId\":1,\"userId\":1,\"total\":0,\"createUserId\":1}]', 38, '0:0:0:0:0:0:0:1', '2021-07-04 15:45:48');
INSERT INTO `sys_log` VALUES (54, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":3,\"bookId\":1,\"userId\":1,\"total\":0,\"createUserId\":1}]', 14, '0:0:0:0:0:0:0:1', '2021-07-04 15:46:29');
INSERT INTO `sys_log` VALUES (55, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":4,\"bookId\":2,\"userId\":1,\"total\":1,\"createUserId\":1}]', 37, '0:0:0:0:0:0:0:1', '2021-07-04 15:49:03');
INSERT INTO `sys_log` VALUES (56, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":5,\"bookId\":2,\"userId\":1,\"total\":1,\"createUserId\":1}]', 15, '0:0:0:0:0:0:0:1', '2021-07-04 15:56:39');
INSERT INTO `sys_log` VALUES (57, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":6,\"bookId\":2,\"userId\":1,\"total\":1,\"createUserId\":1}]', 41, '0:0:0:0:0:0:0:1', '2021-07-04 15:57:48');
INSERT INTO `sys_log` VALUES (58, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":7,\"bookId\":2,\"userId\":1,\"total\":1,\"needBack\":1,\"createUserId\":1,\"createTime\":\"Jul 4, 2021, 3:58:20 PM\",\"limitTime\":\"Jul 30, 2021, 12:00:00 AM\"}]', 83, '0:0:0:0:0:0:0:1', '2021-07-04 15:58:21');
INSERT INTO `sys_log` VALUES (59, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":8,\"bookId\":2,\"userId\":1,\"total\":1,\"needBack\":1,\"createUserId\":1,\"createTime\":\"Jul 4, 2021, 4:08:46 PM\",\"limitTime\":\"Jul 31, 2021, 12:00:00 AM\"}]', 130, '0:0:0:0:0:0:0:1', '2021-07-04 16:08:47');
INSERT INTO `sys_log` VALUES (60, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":9,\"bookId\":2,\"userId\":1,\"total\":2,\"needBack\":2,\"createUserId\":1,\"createTime\":\"Jul 4, 2021, 4:09:03 PM\",\"limitTime\":\"Jul 22, 2021, 12:00:00 AM\"}]', 26, '0:0:0:0:0:0:0:1', '2021-07-04 16:09:03');
INSERT INTO `sys_log` VALUES (61, 'admin', '修改用户', 'SysBorrowBookController.update()', '[{\"borrowId\":10,\"bookId\":4,\"userId\":1,\"total\":20,\"needBack\":20,\"createUserId\":1,\"createTime\":\"Jul 10, 2021, 3:37:31 PM\",\"limitTime\":\"Jul 16, 2021, 12:00:00 AM\"}]', 161, '0:0:0:0:0:0:0:1', '2021-07-10 15:37:32');
INSERT INTO `sys_log` VALUES (62, 'admin', '保存菜单', 'SysMenuController.save()', '[{\"menuId\":36,\"parentId\":0,\"name\":\"还书管理\",\"url\":\"sys/return\",\"perms\":\"\",\"type\":1,\"icon\":\"menu\",\"orderNum\":0}]', 14, '0:0:0:0:0:0:0:1', '2021-07-10 15:40:06');
INSERT INTO `sys_log` VALUES (63, 'admin', '修改菜单', 'SysMenuController.update()', '[{\"menuId\":36,\"parentId\":34,\"name\":\"还书管理\",\"url\":\"sys/return\",\"perms\":\"\",\"type\":1,\"icon\":\"menu\",\"orderNum\":0}]', 39, '0:0:0:0:0:0:0:1', '2021-07-10 15:40:27');
INSERT INTO `sys_log` VALUES (64, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":4,\"name\":\"你是我的眼\",\"version\":\"1.0.1\",\"vendor\":\"中国人民出版社\",\"publicDate\":\"Jul 31, 2021, 12:00:00 AM\",\"summary\":\"真是一本好书啊\",\"total\":100,\"available\":80,\"status\":1,\"createUserId\":1,\"createTime\":\"Jul 3, 2021, 12:50:46 PM\",\"authorIdList\":[]}]', 325, '0:0:0:0:0:0:0:1', '2021-07-11 11:02:30');
INSERT INTO `sys_log` VALUES (65, 'admin', '修改用户', 'SysBookController.update()', '[{\"bookId\":4,\"name\":\"你是我的眼\",\"version\":\"1.0.1\",\"vendor\":\"中国人民出版社\",\"publicDate\":\"Jul 31, 2021, 12:00:00 AM\",\"summary\":\"真是一本好书啊\",\"total\":100,\"available\":80,\"status\":1,\"createUserId\":1,\"createTime\":\"Jul 3, 2021, 12:50:46 PM\",\"authorIdList\":[1,2]}]', 23, '0:0:0:0:0:0:0:1', '2021-07-11 11:03:20');
INSERT INTO `sys_log` VALUES (66, 'admin', '删除角色', 'SysRoleController.delete()', '[[3]]', 64, '0:0:0:0:0:0:0:1', '2021-07-11 18:17:30');
INSERT INTO `sys_log` VALUES (67, 'admin', '删除角色', 'SysRoleController.delete()', '[[2]]', 11, '0:0:0:0:0:0:0:1', '2021-07-11 18:17:33');
INSERT INTO `sys_log` VALUES (68, 'admin', '删除角色', 'SysRoleController.delete()', '[[1]]', 12, '0:0:0:0:0:0:0:1', '2021-07-11 18:17:36');
INSERT INTO `sys_log` VALUES (69, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":4,\"roleName\":\"超级管理员\",\"remark\":\"拥有所有权限\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,32,34,35,36,-666666],\"createTime\":\"Jul 11, 2021, 6:18:09 PM\"}]', 83, '0:0:0:0:0:0:0:1', '2021-07-11 18:18:10');
INSERT INTO `sys_log` VALUES (70, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":5,\"roleName\":\"管理员\",\"remark\":\"拥有相关权限\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,32,34,35,36,-666666],\"createTime\":\"Jul 11, 2021, 6:18:36 PM\"}]', 49, '0:0:0:0:0:0:0:1', '2021-07-11 18:18:36');
INSERT INTO `sys_log` VALUES (71, 'admin', '保存角色', 'SysRoleController.save()', '[{\"roleId\":6,\"roleName\":\"用户\",\"remark\":\"\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,32,34,35,36,-666666],\"createTime\":\"Jul 11, 2021, 6:18:53 PM\"}]', 76, '0:0:0:0:0:0:0:1', '2021-07-11 18:18:53');
INSERT INTO `sys_log` VALUES (72, 'admin', '修改菜单', 'SysMenuController.update()', '[{\"menuId\":31,\"parentId\":34,\"name\":\"作者管理\",\"url\":\"sys/author\",\"perms\":\"\",\"type\":1,\"icon\":\"geren\",\"orderNum\":0}]', 40, '0:0:0:0:0:0:0:1', '2021-07-11 18:20:11');
INSERT INTO `sys_log` VALUES (73, 'admin', '修改菜单', 'SysMenuController.update()', '[{\"menuId\":32,\"parentId\":34,\"name\":\"图书管理\",\"url\":\"sys/book\",\"perms\":\"\",\"type\":1,\"icon\":\"log\",\"orderNum\":0}]', 16, '0:0:0:0:0:0:0:1', '2021-07-11 18:20:24');
INSERT INTO `sys_log` VALUES (74, 'admin', '修改用户', 'SysUserController.update()', '[{\"userId\":3,\"username\":\"test\",\"salt\":\"OSxJf8kqFfNzQSB05M9W\",\"email\":\"1234@1234.com\",\"mobile\":\"15036616562\",\"status\":1,\"roleIdList\":[6],\"createUserId\":1}]', 251, '0:0:0:0:0:0:0:1', '2021-07-11 18:20:46');
INSERT INTO `sys_log` VALUES (75, 'admin', '修改用户', 'SysUserController.update()', '[{\"userId\":2,\"username\":\"yancy\",\"salt\":\"3tE26TobdgrwuRGzSjuk\",\"email\":\"1249123382@qq.com\",\"mobile\":\"15036616562\",\"status\":1,\"roleIdList\":[5],\"createUserId\":1}]', 17, '0:0:0:0:0:0:0:1', '2021-07-11 18:20:51');
INSERT INTO `sys_log` VALUES (76, 'admin', '修改用户', 'SysUserController.update()', '[{\"userId\":1,\"username\":\"admin\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13612345678\",\"status\":1,\"roleIdList\":[4],\"createUserId\":1}]', 15, '0:0:0:0:0:0:0:1', '2021-07-11 18:20:56');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4  COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
INSERT INTO `sys_menu` VALUES (5, 1, 'SQL监控', 'http://localhost:8080/renren-fast/druid/sql.html', NULL, 1, 'sql', 4);
INSERT INTO `sys_menu` VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
INSERT INTO `sys_menu` VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
INSERT INTO `sys_menu` VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
INSERT INTO `sys_menu` VALUES (31, 34, '作者管理', 'sys/author', '', 1, 'geren', 0);
INSERT INTO `sys_menu` VALUES (32, 34, '图书管理', 'sys/book', '', 1, 'log', 0);
INSERT INTO `sys_menu` VALUES (34, 0, '书籍管理', '', '', 0, 'log', 0);
INSERT INTO `sys_menu` VALUES (35, 34, '借书管理', 'sys/borrow', '', 1, 'admin', 0);
INSERT INTO `sys_menu` VALUES (36, 34, '还书管理', 'sys/return', '', 1, 'menu', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4  COMMENT='文件上传';

-- ----------------------------
-- Records of sys_oss
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4  COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (4, '超级管理员', '拥有所有权限', 1, '2021-07-11 18:18:10');
INSERT INTO `sys_role` VALUES (5, '管理员', '拥有相关权限', 1, '2021-07-11 18:18:36');
INSERT INTO `sys_role` VALUES (6, '用户', '', 1, '2021-07-11 18:18:53');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4  COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (94, 4, 1);
INSERT INTO `sys_role_menu` VALUES (95, 4, 2);
INSERT INTO `sys_role_menu` VALUES (96, 4, 15);
INSERT INTO `sys_role_menu` VALUES (97, 4, 16);
INSERT INTO `sys_role_menu` VALUES (98, 4, 17);
INSERT INTO `sys_role_menu` VALUES (99, 4, 18);
INSERT INTO `sys_role_menu` VALUES (100, 4, 3);
INSERT INTO `sys_role_menu` VALUES (101, 4, 19);
INSERT INTO `sys_role_menu` VALUES (102, 4, 20);
INSERT INTO `sys_role_menu` VALUES (103, 4, 21);
INSERT INTO `sys_role_menu` VALUES (104, 4, 22);
INSERT INTO `sys_role_menu` VALUES (105, 4, 4);
INSERT INTO `sys_role_menu` VALUES (106, 4, 23);
INSERT INTO `sys_role_menu` VALUES (107, 4, 24);
INSERT INTO `sys_role_menu` VALUES (108, 4, 25);
INSERT INTO `sys_role_menu` VALUES (109, 4, 26);
INSERT INTO `sys_role_menu` VALUES (110, 4, 5);
INSERT INTO `sys_role_menu` VALUES (111, 4, 6);
INSERT INTO `sys_role_menu` VALUES (112, 4, 7);
INSERT INTO `sys_role_menu` VALUES (113, 4, 8);
INSERT INTO `sys_role_menu` VALUES (114, 4, 9);
INSERT INTO `sys_role_menu` VALUES (115, 4, 10);
INSERT INTO `sys_role_menu` VALUES (116, 4, 11);
INSERT INTO `sys_role_menu` VALUES (117, 4, 12);
INSERT INTO `sys_role_menu` VALUES (118, 4, 13);
INSERT INTO `sys_role_menu` VALUES (119, 4, 14);
INSERT INTO `sys_role_menu` VALUES (120, 4, 27);
INSERT INTO `sys_role_menu` VALUES (121, 4, 29);
INSERT INTO `sys_role_menu` VALUES (122, 4, 30);
INSERT INTO `sys_role_menu` VALUES (123, 4, 31);
INSERT INTO `sys_role_menu` VALUES (124, 4, 32);
INSERT INTO `sys_role_menu` VALUES (125, 4, 34);
INSERT INTO `sys_role_menu` VALUES (126, 4, 35);
INSERT INTO `sys_role_menu` VALUES (127, 4, 36);
INSERT INTO `sys_role_menu` VALUES (128, 4, -666666);
INSERT INTO `sys_role_menu` VALUES (129, 5, 1);
INSERT INTO `sys_role_menu` VALUES (130, 5, 2);
INSERT INTO `sys_role_menu` VALUES (131, 5, 15);
INSERT INTO `sys_role_menu` VALUES (132, 5, 16);
INSERT INTO `sys_role_menu` VALUES (133, 5, 17);
INSERT INTO `sys_role_menu` VALUES (134, 5, 18);
INSERT INTO `sys_role_menu` VALUES (135, 5, 3);
INSERT INTO `sys_role_menu` VALUES (136, 5, 19);
INSERT INTO `sys_role_menu` VALUES (137, 5, 20);
INSERT INTO `sys_role_menu` VALUES (138, 5, 21);
INSERT INTO `sys_role_menu` VALUES (139, 5, 22);
INSERT INTO `sys_role_menu` VALUES (140, 5, 4);
INSERT INTO `sys_role_menu` VALUES (141, 5, 23);
INSERT INTO `sys_role_menu` VALUES (142, 5, 24);
INSERT INTO `sys_role_menu` VALUES (143, 5, 25);
INSERT INTO `sys_role_menu` VALUES (144, 5, 26);
INSERT INTO `sys_role_menu` VALUES (145, 5, 5);
INSERT INTO `sys_role_menu` VALUES (146, 5, 6);
INSERT INTO `sys_role_menu` VALUES (147, 5, 7);
INSERT INTO `sys_role_menu` VALUES (148, 5, 8);
INSERT INTO `sys_role_menu` VALUES (149, 5, 9);
INSERT INTO `sys_role_menu` VALUES (150, 5, 10);
INSERT INTO `sys_role_menu` VALUES (151, 5, 11);
INSERT INTO `sys_role_menu` VALUES (152, 5, 12);
INSERT INTO `sys_role_menu` VALUES (153, 5, 13);
INSERT INTO `sys_role_menu` VALUES (154, 5, 14);
INSERT INTO `sys_role_menu` VALUES (155, 5, 27);
INSERT INTO `sys_role_menu` VALUES (156, 5, 29);
INSERT INTO `sys_role_menu` VALUES (157, 5, 30);
INSERT INTO `sys_role_menu` VALUES (158, 5, 31);
INSERT INTO `sys_role_menu` VALUES (159, 5, 32);
INSERT INTO `sys_role_menu` VALUES (160, 5, 34);
INSERT INTO `sys_role_menu` VALUES (161, 5, 35);
INSERT INTO `sys_role_menu` VALUES (162, 5, 36);
INSERT INTO `sys_role_menu` VALUES (163, 5, -666666);
INSERT INTO `sys_role_menu` VALUES (164, 6, 1);
INSERT INTO `sys_role_menu` VALUES (165, 6, 2);
INSERT INTO `sys_role_menu` VALUES (166, 6, 15);
INSERT INTO `sys_role_menu` VALUES (167, 6, 16);
INSERT INTO `sys_role_menu` VALUES (168, 6, 17);
INSERT INTO `sys_role_menu` VALUES (169, 6, 18);
INSERT INTO `sys_role_menu` VALUES (170, 6, 3);
INSERT INTO `sys_role_menu` VALUES (171, 6, 19);
INSERT INTO `sys_role_menu` VALUES (172, 6, 20);
INSERT INTO `sys_role_menu` VALUES (173, 6, 21);
INSERT INTO `sys_role_menu` VALUES (174, 6, 22);
INSERT INTO `sys_role_menu` VALUES (175, 6, 4);
INSERT INTO `sys_role_menu` VALUES (176, 6, 23);
INSERT INTO `sys_role_menu` VALUES (177, 6, 24);
INSERT INTO `sys_role_menu` VALUES (178, 6, 25);
INSERT INTO `sys_role_menu` VALUES (179, 6, 26);
INSERT INTO `sys_role_menu` VALUES (180, 6, 5);
INSERT INTO `sys_role_menu` VALUES (181, 6, 6);
INSERT INTO `sys_role_menu` VALUES (182, 6, 7);
INSERT INTO `sys_role_menu` VALUES (183, 6, 8);
INSERT INTO `sys_role_menu` VALUES (184, 6, 9);
INSERT INTO `sys_role_menu` VALUES (185, 6, 10);
INSERT INTO `sys_role_menu` VALUES (186, 6, 11);
INSERT INTO `sys_role_menu` VALUES (187, 6, 12);
INSERT INTO `sys_role_menu` VALUES (188, 6, 13);
INSERT INTO `sys_role_menu` VALUES (189, 6, 14);
INSERT INTO `sys_role_menu` VALUES (190, 6, 27);
INSERT INTO `sys_role_menu` VALUES (191, 6, 29);
INSERT INTO `sys_role_menu` VALUES (192, 6, 30);
INSERT INTO `sys_role_menu` VALUES (193, 6, 31);
INSERT INTO `sys_role_menu` VALUES (194, 6, 32);
INSERT INTO `sys_role_menu` VALUES (195, 6, 34);
INSERT INTO `sys_role_menu` VALUES (196, 6, 35);
INSERT INTO `sys_role_menu` VALUES (197, 6, 36);
INSERT INTO `sys_role_menu` VALUES (198, 6, -666666);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4  COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '12e416902db93462bf888e3dc0792be42ecd8a54a6c8ca63ba68cdd35947da15', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', 1, 1, '2016-11-11 11:11:11');
INSERT INTO `sys_user` VALUES (2, 'yancy', 'ce218fc25a13eb29b24b37a99fe098d9b23a55d71445adbc591947a73be9c2c8', '3tE26TobdgrwuRGzSjuk', '1249123382@qq.com', '15036616562', 1, 1, '2021-06-26 14:51:45');
INSERT INTO `sys_user` VALUES (3, 'test', '5b18dd289c913342d5befa549dd4ee5ecf5a67f2924ff93551a45606f9055c7d', 'OSxJf8kqFfNzQSB05M9W', '1234@1234.com', '15036616562', 1, 1, '2021-06-26 16:04:55');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4  COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (4, 3, 6);
INSERT INTO `sys_user_role` VALUES (5, 2, 5);
INSERT INTO `sys_user_role` VALUES (6, 1, 4);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4  COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES (1, '02549c0d633e6cfca81e20f8b42ceb0d', '2021-07-12 06:19:28', '2021-07-11 18:19:28');
INSERT INTO `sys_user_token` VALUES (2, '40ff88e12be6f1b5d43ec631d4d0a828', '2021-06-27 02:52:03', '2021-06-26 14:52:03');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4  COMMENT='用户';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
